Dataset statistics
| Number of variables | 9 |
|---|---|
| Number of observations | 496 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 35.0 KiB |
| Average record size in memory | 72.3 B |
Variable types
| Categorical | 1 |
|---|---|
| Numeric | 8 |
date has a high cardinality: 496 distinct values | High cardinality |
Coquimbo is highly correlated with Valparaiso and 4 other fields | High correlation |
Valparaiso is highly correlated with Coquimbo and 6 other fields | High correlation |
Metropolitana_de_Santiago is highly correlated with Coquimbo and 6 other fields | High correlation |
Libertador_Gral__Bernardo_O_Higgins is highly correlated with Coquimbo and 6 other fields | High correlation |
Maule is highly correlated with Coquimbo and 6 other fields | High correlation |
Biobio is highly correlated with Coquimbo and 6 other fields | High correlation |
La_Araucania is highly correlated with Valparaiso and 5 other fields | High correlation |
Los_Rios is highly correlated with Valparaiso and 5 other fields | High correlation |
Coquimbo is highly correlated with Valparaiso and 5 other fields | High correlation |
Valparaiso is highly correlated with Coquimbo and 6 other fields | High correlation |
Metropolitana_de_Santiago is highly correlated with Coquimbo and 6 other fields | High correlation |
Libertador_Gral__Bernardo_O_Higgins is highly correlated with Coquimbo and 6 other fields | High correlation |
Maule is highly correlated with Coquimbo and 6 other fields | High correlation |
Biobio is highly correlated with Coquimbo and 6 other fields | High correlation |
La_Araucania is highly correlated with Coquimbo and 6 other fields | High correlation |
Los_Rios is highly correlated with Valparaiso and 5 other fields | High correlation |
Coquimbo is highly correlated with Valparaiso and 2 other fields | High correlation |
Valparaiso is highly correlated with Coquimbo and 5 other fields | High correlation |
Metropolitana_de_Santiago is highly correlated with Coquimbo and 6 other fields | High correlation |
Libertador_Gral__Bernardo_O_Higgins is highly correlated with Coquimbo and 6 other fields | High correlation |
Maule is highly correlated with Valparaiso and 5 other fields | High correlation |
Biobio is highly correlated with Valparaiso and 5 other fields | High correlation |
La_Araucania is highly correlated with Valparaiso and 5 other fields | High correlation |
Los_Rios is highly correlated with Metropolitana_de_Santiago and 4 other fields | High correlation |
Libertador_Gral__Bernardo_O_Higgins is highly correlated with La_Araucania and 6 other fields | High correlation |
La_Araucania is highly correlated with Libertador_Gral__Bernardo_O_Higgins and 5 other fields | High correlation |
Valparaiso is highly correlated with Libertador_Gral__Bernardo_O_Higgins and 6 other fields | High correlation |
Metropolitana_de_Santiago is highly correlated with Libertador_Gral__Bernardo_O_Higgins and 6 other fields | High correlation |
Maule is highly correlated with Libertador_Gral__Bernardo_O_Higgins and 6 other fields | High correlation |
Los_Rios is highly correlated with Libertador_Gral__Bernardo_O_Higgins and 5 other fields | High correlation |
Biobio is highly correlated with Libertador_Gral__Bernardo_O_Higgins and 6 other fields | High correlation |
Coquimbo is highly correlated with Libertador_Gral__Bernardo_O_Higgins and 4 other fields | High correlation |
date is uniformly distributed | Uniform |
date has unique values | Unique |
Maule has unique values | Unique |
Biobio has unique values | Unique |
La_Araucania has unique values | Unique |
Los_Rios has unique values | Unique |
Coquimbo has 5 (1.0%) zeros | Zeros |
Valparaiso has 7 (1.4%) zeros | Zeros |
Libertador_Gral__Bernardo_O_Higgins has 8 (1.6%) zeros | Zeros |
Reproduction
| Analysis started | 2021-08-02 02:35:08.101387 |
|---|---|
| Analysis finished | 2021-08-02 02:35:14.040956 |
| Duration | 5.94 seconds |
| Software version | pandas-profiling v3.0.0 |
| Download configuration | config.json |
| Distinct | 496 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.0 KiB |
| 1989-02-01 | 1 |
|---|---|
| 2002-07-01 | 1 |
| 1988-09-01 | 1 |
| 2012-06-01 | 1 |
| 2006-06-01 | 1 |
| Other values (491) |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Characters and Unicode
| Total characters | 4960 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 496 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | 1989-02-01 |
|---|---|
| 2nd row | 1998-10-01 |
| 3rd row | 2001-02-01 |
| 4th row | 2008-11-01 |
| 5th row | 2009-04-01 |
Common Values
| Value | Count | Frequency (%) |
| 1989-02-01 | 1 | 0.2% |
| 2002-07-01 | 1 | 0.2% |
| 1988-09-01 | 1 | 0.2% |
| 2012-06-01 | 1 | 0.2% |
| 2006-06-01 | 1 | 0.2% |
| 1989-06-01 | 1 | 0.2% |
| 2007-05-01 | 1 | 0.2% |
| 2011-04-01 | 1 | 0.2% |
| 1993-02-01 | 1 | 0.2% |
| 1987-08-01 | 1 | 0.2% |
| Other values (486) | 486 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| 1989-02-01 | 1 | 0.2% |
| 2002-07-01 | 1 | 0.2% |
| 1988-09-01 | 1 | 0.2% |
| 2012-06-01 | 1 | 0.2% |
| 2006-06-01 | 1 | 0.2% |
| 1989-06-01 | 1 | 0.2% |
| 2007-05-01 | 1 | 0.2% |
| 2011-04-01 | 1 | 0.2% |
| 1993-02-01 | 1 | 0.2% |
| 1987-08-01 | 1 | 0.2% |
| Other values (486) | 486 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 1326 | |
| 1 | 1122 | |
| - | 992 | |
| 9 | 473 | 9.5% |
| 2 | 379 | 7.6% |
| 8 | 209 | 4.2% |
| 7 | 101 | 2.0% |
| 4 | 90 | 1.8% |
| 3 | 90 | 1.8% |
| 5 | 89 | 1.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 3968 | |
| Dash Punctuation | 992 | 20.0% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 1326 | |
| 1 | 1122 | |
| 9 | 473 | 11.9% |
| 2 | 379 | 9.6% |
| 8 | 209 | 5.3% |
| 7 | 101 | 2.5% |
| 4 | 90 | 2.3% |
| 3 | 90 | 2.3% |
| 5 | 89 | 2.2% |
| 6 | 89 | 2.2% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 992 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 4960 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 1326 | |
| 1 | 1122 | |
| - | 992 | |
| 9 | 473 | 9.5% |
| 2 | 379 | 7.6% |
| 8 | 209 | 4.2% |
| 7 | 101 | 2.0% |
| 4 | 90 | 1.8% |
| 3 | 90 | 1.8% |
| 5 | 89 | 1.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 4960 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 1326 | |
| 1 | 1122 | |
| - | 992 | |
| 9 | 473 | 9.5% |
| 2 | 379 | 7.6% |
| 8 | 209 | 4.2% |
| 7 | 101 | 2.0% |
| 4 | 90 | 1.8% |
| 3 | 90 | 1.8% |
| 5 | 89 | 1.8% |
| Distinct | 492 |
|---|---|
| Distinct (%) | 99.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 16.15469103 |
| Minimum | 0 |
|---|---|
| Maximum | 347.1338889 |
| Zeros | 5 |
| Zeros (%) | 1.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.06191503269 |
| Q1 | 0.8215212434 |
| median | 4.071035946 |
| Q3 | 16.13759968 |
| 95-th percentile | 68.23522061 |
| Maximum | 347.1338889 |
| Range | 347.1338889 |
| Interquartile range (IQR) | 15.31607844 |
Descriptive statistics
| Standard deviation | 32.62928614 |
|---|---|
| Coefficient of variation (CV) | 2.01980255 |
| Kurtosis | 35.85786972 |
| Mean | 16.15469103 |
| Median Absolute Deviation (MAD) | 3.818003267 |
| Skewness | 4.969772006 |
| Sum | 8012.726752 |
| Variance | 1064.670314 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 5 | 1.0% |
| 17.26315033 | 1 | 0.2% |
| 5.071111113 | 1 | 0.2% |
| 11.71917647 | 1 | 0.2% |
| 0.781071895 | 1 | 0.2% |
| 7.360718955 | 1 | 0.2% |
| 112.1740132 | 1 | 0.2% |
| 0.2603398698 | 1 | 0.2% |
| 4.629065357 | 1 | 0.2% |
| 7.016032688 | 1 | 0.2% |
| Other values (482) | 482 |
| Value | Count | Frequency (%) |
| 0 | 5 | |
| 0.0001895424782 | 1 | 0.2% |
| 0.0003202614441 | 1 | 0.2% |
| 0.0007189542639 | 1 | 0.2% |
| 0.003450980392 | 1 | 0.2% |
| 0.004444444413 | 1 | 0.2% |
| 0.008065359499 | 1 | 0.2% |
| 0.009137254962 | 1 | 0.2% |
| 0.0105163397 | 1 | 0.2% |
| 0.01120915047 | 1 | 0.2% |
| Value | Count | Frequency (%) |
| 347.1338889 | 1 | |
| 270.4372873 | 1 | |
| 260.3330655 | 1 | |
| 147.1629085 | 1 | |
| 137.975549 | 1 | |
| 136.2123269 | 1 | |
| 135.6549804 | 1 | |
| 120.4530392 | 1 | |
| 113.7854968 | 1 | |
| 112.1740132 | 1 |
| Distinct | 490 |
|---|---|
| Distinct (%) | 98.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 32.45098021 |
| Minimum | 0 |
|---|---|
| Maximum | 441.0486039 |
| Zeros | 7 |
| Zeros (%) | 1.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.03691558428 |
| Q1 | 1.53816153 |
| median | 9.037824679 |
| Q3 | 38.4092126 |
| 95-th percentile | 127.953535 |
| Maximum | 441.0486039 |
| Range | 441.0486039 |
| Interquartile range (IQR) | 36.87105107 |
Descriptive statistics
| Standard deviation | 55.43433032 |
|---|---|
| Coefficient of variation (CV) | 1.708248255 |
| Kurtosis | 16.15727121 |
| Mean | 32.45098021 |
| Median Absolute Deviation (MAD) | 8.807775978 |
| Skewness | 3.418567302 |
| Sum | 16095.68618 |
| Variance | 3072.964978 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 7 | 1.4% |
| 0.5341396084 | 1 | 0.2% |
| 0.6626623377 | 1 | 0.2% |
| 6.44090909 | 1 | 0.2% |
| 21.93813312 | 1 | 0.2% |
| 95.17995126 | 1 | 0.2% |
| 78.17058439 | 1 | 0.2% |
| 25.31423701 | 1 | 0.2% |
| 14.21741886 | 1 | 0.2% |
| 7.089090916 | 1 | 0.2% |
| Other values (480) | 480 |
| Value | Count | Frequency (%) |
| 0 | 7 | |
| 4.870129761 × 10-5 | 1 | 0.2% |
| 0.0002435065032 | 1 | 0.2% |
| 0.0004058441558 | 1 | 0.2% |
| 0.0006655844156 | 1 | 0.2% |
| 0.002224025976 | 1 | 0.2% |
| 0.003360389502 | 1 | 0.2% |
| 0.003701298701 | 1 | 0.2% |
| 0.01798701303 | 1 | 0.2% |
| 0.01961038945 | 1 | 0.2% |
| Value | Count | Frequency (%) |
| 441.0486039 | 1 | |
| 404.7016559 | 1 | |
| 369.6516397 | 1 | |
| 353.7640257 | 1 | |
| 307.3663146 | 1 | |
| 245.5831979 | 1 | |
| 243.1342045 | 1 | |
| 223.6828733 | 1 | |
| 201.3870456 | 1 | |
| 197.554253 | 1 |
Metropolitana_de_Santiago
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATION| Distinct | 494 |
|---|---|
| Distinct (%) | 99.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 49.66668249 |
| Minimum | 0 |
|---|---|
| Maximum | 524.5926671 |
| Zeros | 3 |
| Zeros (%) | 0.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.2132802003 |
| Q1 | 5.297546145 |
| median | 19.08759229 |
| Q3 | 63.40836403 |
| 95-th percentile | 186.6450672 |
| Maximum | 524.5926671 |
| Range | 524.5926671 |
| Interquartile range (IQR) | 58.11081789 |
Descriptive statistics
| Standard deviation | 74.36109868 |
|---|---|
| Coefficient of variation (CV) | 1.497202852 |
| Kurtosis | 10.79959059 |
| Mean | 49.66668249 |
| Median Absolute Deviation (MAD) | 17.29051175 |
| Skewness | 2.861950599 |
| Sum | 24634.67451 |
| Variance | 5529.572996 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 3 | 0.6% |
| 0.02827181207 | 1 | 0.2% |
| 192.0948491 | 1 | 0.2% |
| 19.89310398 | 1 | 0.2% |
| 25.70741609 | 1 | 0.2% |
| 162.3165773 | 1 | 0.2% |
| 126.2724164 | 1 | 0.2% |
| 51.46986583 | 1 | 0.2% |
| 25.66223159 | 1 | 0.2% |
| 27.6678188 | 1 | 0.2% |
| Other values (484) | 484 |
| Value | Count | Frequency (%) |
| 0 | 3 | |
| 0.002634228201 | 1 | 0.2% |
| 0.006208053646 | 1 | 0.2% |
| 0.009395973244 | 1 | 0.2% |
| 0.01018456387 | 1 | 0.2% |
| 0.01149328823 | 1 | 0.2% |
| 0.01186241608 | 1 | 0.2% |
| 0.0158724834 | 1 | 0.2% |
| 0.02114093986 | 1 | 0.2% |
| 0.02827181207 | 1 | 0.2% |
| Value | Count | Frequency (%) |
| 524.5926671 | 1 | |
| 481.1297151 | 1 | |
| 475.4633393 | 1 | |
| 437.6334061 | 1 | |
| 417.0693793 | 1 | |
| 344.1065435 | 1 | |
| 329.392835 | 1 | |
| 306.3366108 | 1 | |
| 296.6260912 | 1 | |
| 288.9177179 | 1 |
Libertador_Gral__Bernardo_O_Higgins
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONZEROS| Distinct | 489 |
|---|---|
| Distinct (%) | 98.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 72.24980496 |
| Minimum | 0 |
|---|---|
| Maximum | 645.5157516 |
| Zeros | 8 |
| Zeros (%) | 1.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.07898837202 |
| Q1 | 5.343992242 |
| median | 25.99596898 |
| Q3 | 101.8750929 |
| 95-th percentile | 275.7165937 |
| Maximum | 645.5157516 |
| Range | 645.5157516 |
| Interquartile range (IQR) | 96.53110066 |
Descriptive statistics
| Standard deviation | 101.4261116 |
|---|---|
| Coefficient of variation (CV) | 1.403825403 |
| Kurtosis | 6.443053958 |
| Mean | 72.24980496 |
| Median Absolute Deviation (MAD) | 25.27256588 |
| Skewness | 2.280482399 |
| Sum | 35835.90326 |
| Variance | 10287.25611 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 8 | 1.6% |
| 5.897829446 | 1 | 0.2% |
| 2.175643403 | 1 | 0.2% |
| 26.17671314 | 1 | 0.2% |
| 36.28063562 | 1 | 0.2% |
| 271.111008 | 1 | 0.2% |
| 248.1633646 | 1 | 0.2% |
| 91.17899219 | 1 | 0.2% |
| 39.32105422 | 1 | 0.2% |
| 85.76629462 | 1 | 0.2% |
| Other values (479) | 479 |
| Value | Count | Frequency (%) |
| 0 | 8 | |
| 0.0005581395571 | 1 | 0.2% |
| 0.00235658921 | 1 | 0.2% |
| 0.003054263518 | 1 | 0.2% |
| 0.006682170601 | 1 | 0.2% |
| 0.009674418527 | 1 | 0.2% |
| 0.01106976737 | 1 | 0.2% |
| 0.01297674405 | 1 | 0.2% |
| 0.01762790698 | 1 | 0.2% |
| 0.02004651154 | 1 | 0.2% |
| Value | Count | Frequency (%) |
| 645.5157516 | 1 | |
| 615.0033638 | 1 | |
| 580.1555192 | 1 | |
| 491.2167134 | 1 | |
| 489.9746362 | 1 | |
| 459.3477678 | 1 | |
| 451.954589 | 1 | |
| 418.6066354 | 1 | |
| 389.6408833 | 1 | |
| 373.557271 | 1 |
| Distinct | 496 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 98.66277342 |
| Minimum | 0 |
|---|---|
| Maximum | 759.1777124 |
| Zeros | 1 |
| Zeros (%) | 0.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.7408652256 |
| Q1 | 11.89736272 |
| median | 45.64988768 |
| Q3 | 142.2307156 |
| 95-th percentile | 353.4197152 |
| Maximum | 759.1777124 |
| Range | 759.1777124 |
| Interquartile range (IQR) | 130.3333528 |
Descriptive statistics
| Standard deviation | 122.7667708 |
|---|---|
| Coefficient of variation (CV) | 1.244306911 |
| Kurtosis | 4.086940274 |
| Mean | 98.66277342 |
| Median Absolute Deviation (MAD) | 41.54554078 |
| Skewness | 1.908906221 |
| Sum | 48936.73562 |
| Variance | 15071.68002 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0.7246672216 | 1 | 0.2% |
| 191.6120465 | 1 | 0.2% |
| 57.51771212 | 1 | 0.2% |
| 318.6413477 | 1 | 0.2% |
| 385.2430455 | 1 | 0.2% |
| 183.7435608 | 1 | 0.2% |
| 34.77559072 | 1 | 0.2% |
| 107.3741847 | 1 | 0.2% |
| 2.696705486 | 1 | 0.2% |
| 291.8520964 | 1 | 0.2% |
| Other values (486) | 486 |
| Value | Count | Frequency (%) |
| 0 | 1 | |
| 0.00237936776 | 1 | |
| 0.008968385999 | 1 | |
| 0.01192179692 | 1 | |
| 0.02545757066 | 1 | |
| 0.02969217952 | 1 | |
| 0.03216306155 | 1 | |
| 0.1155657238 | 1 | |
| 0.1785607306 | 1 | |
| 0.2004825291 | 1 |
| Value | Count | Frequency (%) |
| 759.1777124 | 1 | |
| 643.3674795 | 1 | |
| 577.7182612 | 1 | |
| 568.8898255 | 1 | |
| 545.9031532 | 1 | |
| 534.3563891 | 1 | |
| 532.5694011 | 1 | |
| 495.973552 | 1 | |
| 482.1990092 | 1 | |
| 481.2721546 | 1 |
| Distinct | 496 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 128.1134058 |
| Minimum | 0.00117021276 |
|---|---|
| Maximum | 702.434707 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.0 KiB |
Quantile statistics
| Minimum | 0.00117021276 |
|---|---|
| 5-th percentile | 5.195947475 |
| Q1 | 29.35668384 |
| median | 79.55855717 |
| Q3 | 184.7513066 |
| 95-th percentile | 403.1391807 |
| Maximum | 702.434707 |
| Range | 702.4335368 |
| Interquartile range (IQR) | 155.3946228 |
Descriptive statistics
| Standard deviation | 130.0560942 |
|---|---|
| Coefficient of variation (CV) | 1.015163818 |
| Kurtosis | 2.141751033 |
| Mean | 128.1134058 |
| Median Absolute Deviation (MAD) | 61.63801526 |
| Skewness | 1.48873246 |
| Sum | 63544.24928 |
| Variance | 16914.58764 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 9.172945482 | 1 | 0.2% |
| 192.4655252 | 1 | 0.2% |
| 62.11212098 | 1 | 0.2% |
| 331.5838563 | 1 | 0.2% |
| 461.2940224 | 1 | 0.2% |
| 340.0757445 | 1 | 0.2% |
| 65.43378327 | 1 | 0.2% |
| 126.605512 | 1 | 0.2% |
| 0.504461436 | 1 | 0.2% |
| 266.8346078 | 1 | 0.2% |
| Other values (486) | 486 |
| Value | Count | Frequency (%) |
| 0.00117021276 | 1 | |
| 0.06371010613 | 1 | |
| 0.1831316497 | 1 | |
| 0.2710904255 | 1 | |
| 0.3154055852 | 1 | |
| 0.4150132992 | 1 | |
| 0.4365757964 | 1 | |
| 0.504461436 | 1 | |
| 0.5304920241 | 1 | |
| 0.6762765948 | 1 |
| Value | Count | Frequency (%) |
| 702.434707 | 1 | |
| 684.9585037 | 1 | |
| 617.324714 | 1 | |
| 607.5404853 | 1 | |
| 563.8422746 | 1 | |
| 556.5594612 | 1 | |
| 526.3377325 | 1 | |
| 505.8819284 | 1 | |
| 489.7354649 | 1 | |
| 482.4539624 | 1 |
| Distinct | 496 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 151.4864559 |
| Minimum | 0.005331302395 |
|---|---|
| Maximum | 661.2112029 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.0 KiB |
Quantile statistics
| Minimum | 0.005331302395 |
|---|---|
| 5-th percentile | 16.27306551 |
| Q1 | 52.93034274 |
| median | 110.5709901 |
| Q3 | 208.3162434 |
| 95-th percentile | 404.1772219 |
| Maximum | 661.2112029 |
| Range | 661.2058716 |
| Interquartile range (IQR) | 155.3859006 |
Descriptive statistics
| Standard deviation | 126.628503 |
|---|---|
| Coefficient of variation (CV) | 0.835906433 |
| Kurtosis | 1.248656826 |
| Mean | 151.4864559 |
| Median Absolute Deviation (MAD) | 72.76584167 |
| Skewness | 1.236218224 |
| Sum | 75137.28214 |
| Variance | 16034.77778 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 22.59583397 | 1 | 0.2% |
| 191.1856132 | 1 | 0.2% |
| 85.13408224 | 1 | 0.2% |
| 379.0605102 | 1 | 0.2% |
| 472.6612111 | 1 | 0.2% |
| 346.003991 | 1 | 0.2% |
| 108.857898 | 1 | 0.2% |
| 166.6704874 | 1 | 0.2% |
| 5.333297787 | 1 | 0.2% |
| 248.593222 | 1 | 0.2% |
| Other values (486) | 486 |
| Value | Count | Frequency (%) |
| 0.005331302395 | 1 | |
| 0.1469763899 | 1 | |
| 0.6615460784 | 1 | |
| 1.373297793 | 1 | |
| 1.481629856 | 1 | |
| 2.081165269 | 1 | |
| 2.834790552 | 1 | |
| 3.372718965 | 1 | |
| 4.114371663 | 1 | |
| 5.294904797 | 1 |
| Value | Count | Frequency (%) |
| 661.2112029 | 1 | |
| 639.4612567 | 1 | |
| 580.0809754 | 1 | |
| 576.974463 | 1 | |
| 564.7615766 | 1 | |
| 553.0533433 | 1 | |
| 538.3699849 | 1 | |
| 501.5264355 | 1 | |
| 486.3164129 | 1 | |
| 482.6669841 | 1 |
| Distinct | 496 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 199.4517892 |
| Minimum | 0.7481266175 |
|---|---|
| Maximum | 717.7356727 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.0 KiB |
Quantile statistics
| Minimum | 0.7481266175 |
|---|---|
| 5-th percentile | 37.33926037 |
| Q1 | 89.80564282 |
| median | 159.4679395 |
| Q3 | 274.5945898 |
| 95-th percentile | 475.61688 |
| Maximum | 717.7356727 |
| Range | 716.9875461 |
| Interquartile range (IQR) | 184.7889469 |
Descriptive statistics
| Standard deviation | 140.0736146 |
|---|---|
| Coefficient of variation (CV) | 0.7022930963 |
| Kurtosis | 0.6124866119 |
| Mean | 199.4517892 |
| Median Absolute Deviation (MAD) | 85.80759069 |
| Skewness | 1.007050639 |
| Sum | 98928.08742 |
| Variance | 19620.6175 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 52.26801038 | 1 | 0.2% |
| 271.3444446 | 1 | 0.2% |
| 122.7150518 | 1 | 0.2% |
| 426.4888634 | 1 | 0.2% |
| 549.4147417 | 1 | 0.2% |
| 381.1321062 | 1 | 0.2% |
| 134.4060595 | 1 | 0.2% |
| 199.0752713 | 1 | 0.2% |
| 24.39341083 | 1 | 0.2% |
| 279.6964083 | 1 | 0.2% |
| Other values (486) | 486 |
| Value | Count | Frequency (%) |
| 0.7481266175 | 1 | |
| 1.462816541 | 1 | |
| 1.669457368 | 1 | |
| 4.671356599 | 1 | |
| 6.842984498 | 1 | |
| 14.01120154 | 1 | |
| 16.65549096 | 1 | |
| 17.26673129 | 1 | |
| 17.61639533 | 1 | |
| 20.3295995 | 1 |
| Value | Count | Frequency (%) |
| 717.7356727 | 1 | |
| 711.4950254 | 1 | |
| 669.5568603 | 1 | |
| 645.7635919 | 1 | |
| 642.5441348 | 1 | |
| 572.9727647 | 1 | |
| 569.9676353 | 1 | |
| 566.5381659 | 1 | |
| 551.5668085 | 1 | |
| 549.4147417 | 1 |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here. A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
First rows
| date | Coquimbo | Valparaiso | Metropolitana_de_Santiago | Libertador_Gral__Bernardo_O_Higgins | Maule | Biobio | La_Araucania | Los_Rios | |
|---|---|---|---|---|---|---|---|---|---|
| 0 | 1989-02-01 | 0.719033 | 0.117045 | 0.028272 | 0.000000 | 0.724667 | 9.172945 | 22.595834 | 52.268010 |
| 1 | 1998-10-01 | 0.065216 | 0.000000 | 0.011493 | 0.000000 | 0.008968 | 2.089674 | 14.702087 | 45.142041 |
| 2 | 2001-02-01 | 2.030026 | 0.047987 | 0.002634 | 0.000000 | 0.032163 | 10.768351 | 29.465057 | 65.571098 |
| 3 | 2008-11-01 | 0.622784 | 0.000000 | 0.015872 | 0.000000 | 1.734168 | 25.083557 | 64.901645 | 113.093488 |
| 4 | 2009-04-01 | 0.008065 | 0.000000 | 0.009396 | 0.000000 | 12.080715 | 56.233424 | 96.364235 | 155.622235 |
| 5 | 2015-01-01 | 0.239366 | 0.025617 | 0.365453 | 0.000000 | 0.011922 | 0.001170 | 0.005331 | 1.462817 |
| 6 | 2016-03-01 | 1.410340 | 0.173750 | 0.056896 | 0.000000 | 0.464601 | 15.188883 | 28.314859 | 42.045866 |
| 7 | 2020-03-01 | 0.003451 | 0.000666 | 0.000000 | 0.000000 | 0.115566 | 12.462699 | 28.310937 | 73.640866 |
| 8 | 1988-12-01 | 3.605386 | 7.686461 | 5.764245 | 1.353364 | 5.670358 | 29.855126 | 61.418941 | 105.088928 |
| 9 | 2015-12-01 | 0.272739 | 0.283084 | 0.688792 | 0.410341 | 0.513311 | 20.054594 | 71.496481 | 103.072700 |
Last rows
| date | Coquimbo | Valparaiso | Metropolitana_de_Santiago | Libertador_Gral__Bernardo_O_Higgins | Maule | Biobio | La_Araucania | Los_Rios | |
|---|---|---|---|---|---|---|---|---|---|
| 486 | 2004-12-01 | 0.050556 | 0.438539 | 5.346997 | 13.841411 | 44.798744 | 33.314475 | 52.080335 | 115.730698 |
| 487 | 1998-04-01 | 26.984346 | 45.800033 | 67.689564 | 73.363163 | 71.475524 | 74.345904 | 78.063648 | 116.467493 |
| 488 | 1991-10-01 | 2.244458 | 17.269968 | 36.332550 | 52.353550 | 80.464002 | 82.242786 | 77.135149 | 109.656628 |
| 489 | 2011-03-01 | 1.553065 | 4.684269 | 9.450067 | 21.832403 | 36.230033 | 59.200891 | 90.166794 | 158.491137 |
| 490 | 2018-03-01 | 0.083333 | 1.501153 | 3.839144 | 17.900047 | 41.166140 | 87.381849 | 144.213397 | 250.525723 |
| 491 | 1988-10-01 | 0.000000 | 0.019886 | 4.621711 | 8.260992 | 27.616980 | 69.572460 | 133.732635 | 181.879767 |
| 492 | 2019-08-01 | 0.000000 | 0.430990 | 4.509748 | 9.900806 | 49.285557 | 108.404827 | 155.448370 | 233.621020 |
| 493 | 2015-06-01 | 0.000000 | 0.325714 | 4.888708 | 33.152636 | 117.695499 | 255.274275 | 343.280205 | 386.836253 |
| 494 | 2016-09-01 | 0.000000 | 0.035860 | 1.066980 | 3.090961 | 18.736997 | 45.646802 | 74.499307 | 119.114419 |
| 495 | 1982-04-01 | 0.000000 | 0.019610 | 6.848607 | 16.891752 | 28.904933 | 41.035299 | 47.870769 | 89.875426 |